CREATE procedure [dbo].[BAEEventAddRegistrant] @UID VARCHAR(16),
      @RegistrantID VARCHAR(16),
      @EventCode VARCHAR(16),
      @SessionStartDate DATETIME,
      @RegistrantClass VARCHAR(32),
      @F_Name VARCHAR(24),
      @M_Initial VARCHAR(24),
      @L_Name VARCHAR(32),
      @Address_1 VARCHAR(128),
      @Address_2 VARCHAR(128),
      @Address_3 VARCHAR(128),
      @City VARCHAR(64),
      @State VARCHAR(48),
      @PostalCode VARCHAR(16),
      @ApplyChanges bit,
      @Purpose varchar(64),
      @Phone varchar(32),
      @Email varchar(128),
      @Country varchar(25) as

IF @EventCode!=''
BEGIN
SELECT * FROM EventRegistrant
WHERE RegistrantID = @RegistrantID AND EventCode=@EventCode;

IF @@rowcount > 0
      BEGIN
            UPDATE EventRegistrant
                  SET   UserID = @UID,    RegistrantID = @RegistrantID, EventCode = @EventCode, SessionStartDate = @SessionStartDate, RegistrantClass = @RegistrantClass, FirstName = @F_Name, MiddleInitial = @M_Initial, LastName = @L_Name, Address1 = @Address_1, Address2 = @Address_2, Address3 = @Address_3, City = @City, StateProvince = @State, PostalCode = @PostalCode, ApplyPermanentChanges = @ApplyChanges, AddressPurpose = @Purpose, Phone = @Phone, Email = @Email, Country = @Country
            WHERE RegistrantID = @RegistrantID AND EventCode=@EventCode;
      END
ELSE
      BEGIN
            INSERT INTO EventRegistrant (
                  UserID,     RegistrantID, EventCode, SessionStartDate, RegistrantClass,  FirstName, MiddleInitial, LastName, Address1, Address2, Address3, City, StateProvince, PostalCode,
                  ApplyPermanentChanges, AddressPurpose, Phone, Email, Country )
            VALUES(
                  @UID, @RegistrantID, @EventCode, @SessionStartDate, @RegistrantClass, @F_Name, @M_Initial, @L_Name, @Address_1,
                  @Address_2, @Address_3, @City, @State, @PostalCode,
                  @ApplyChanges, @Purpose, @Phone, @Email, @Country )
      END
END

GO